package com.example.kiratest.EasyExcel.Mapper;

import com.example.kiratest.EasyExcel.pojo.Excel;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ExcelMapper {
    @Select("select * from excel order by id")
     List<Excel> selectAllOrderById();  //查询数据根据id排序,如果这个要分页的话我们就是用我们的PageHelper

    @Select("select count(*) from excel")
    Integer countTotal();

    @Select("select * from excel where id >#{lastMaxId} order by id limit #{batchsize} ")
    List<Excel> deepPaginationSelect(Integer lastMaxId,Integer batchsize); //深度分页通过书签法解决

}
